It is almost always easier and less error-prone to import existing data - including appending new sampling events - than it is to input data by hand. That said, Sanitas provides an interface for modifying the database once it has been created. (It is not generally recommended that the database file be edited outside of Sanitas, e.g. using Microsoft Access™. If you are interested in directly linking to the .mdb file we suggest you contact us first.)
To launch the Database Editor, select Data File Operations/Edit… from the File menu. The Database Editor contains three tabs: Data Table, which displays individual observations for a selected constituent and/or well and/or date (you must select at least one of these criteria to view data); Constituents; and Monitoring Points. In each case, clicking a row will bring up an editor for that row, and a "new record" button is available in the upper-right-hand corner.
Much of the functionality is self-explanatory, given the description of data fields elsewhere in this document. A few items require explanation:
On the Data Table tab, there is a checkbox labeled "Show Missing Data". To use this feature you must select a date (or date range – you will be prompted to enter a range if your selected date is within a week of another date) and a monitoring point, and you must NOT select a constituent (that is, you must select the blank entry in the constituent list, which is the default). Then checking Show Missing Data will add a row for each constituent which is not found in the database for the selected date(s) and monitoring point. Missing data rows have a yellow background. Like all rows, they can be clicked on to "edit", which in this case means adding a new record for that missing row.
Finally, it should be noted that the Constituents tab is the only location for modifying the following fields: